Hi Guys
I am littlebit confuse about primary key and foreign key while i read online related blogs and articles.I don't understand clear difference between primary key and foreign key.Please clear me difference between primary key and foreign key
Thanks
Simond Gear
27-Jan-2017Here is a some Difference between primary key and Foreign key
Primary key-
A table can have one primary key.
It cannot accept duplicate values.
It is default clustered index
It cannot accept null value
Foreign Key-
Default is Non_Clustered Index
A table can have more than one foreign key
It can accept duplicate value.
It accept null value.
It provide link between data in two table.